Tabela Surgery

Definicja tabeli Surgery

Name

Surgery

Code

Surgery

Comment

Zabiegi przypisane do zakazen szpitalnych


Lista kolumn tabeli Surgery

Name

Code

SurgeryID

SurgeryID

DrainageID

DrainageID

DurationID

DurationID

InfectionID

InfectionID

SurgeryTypeID

SurgeryTypeID

ServID

ServID

CleannessLevelID

CleannessLevelID

AntibacterialProphylaxisID

AntibacterialProphylaxisID

PerfServiceID

PerfServiceID

SurgeryDT

SurgeryDT

WoundDT

WoundDT

Comments

Comments

OtherDrainage

OtherDrainage

OtherBodyPart

OtherBodyPart

WoundToClean

WoundToClean

RoomNo

RoomNo

ICDCode

ICDCode

SurgeryDescr

SurgeryDescr

Implant

Implant

OtherAntibacterialProphylaxis

OtherAntibacterialProphylaxis

DaysBeforeSurgery

DaysBeforeSurgery

LengtheningSurgery

LengtheningSurgery

RepeatSurgery

RepeatSurgery

AntibacterialProphylaxisChemo

AntibacterialProphylaxisChemo

AntibacterialProphylaxisDosNo

AntibacterialProphylaxisDosNo

MultiProceduralSurgery

MultiProceduralSurgery

Trauma

Trauma

ASA

ASA

Videosurgery

Videosurgery


Kolumna SurgeryID tabeli Surgery

Definicja kolumny SurgeryID tabeli Surgery

Name

SurgeryID

Code

SurgeryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrainageID tabeli Surgery

Definicja kolumny DrainageID tabeli Surgery

Name

DrainageID

Code

DrainageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DurationID tabeli Surgery

Definicja kolumny DurationID tabeli Surgery

Name

DurationID

Code

DurationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionID tabeli Surgery

Definicja kolumny InfectionID tabeli Surgery

Name

InfectionID

Code

InfectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SurgeryTypeID tabeli Surgery

Definicja kolumny SurgeryTypeID tabeli Surgery

Name

SurgeryTypeID

Code

SurgeryTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServID tabeli Surgery

Definicja kolumny ServID tabeli Surgery

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CleannessLevelID tabeli Surgery

Definicja kolumny CleannessLevelID tabeli Surgery

Name

CleannessLevelID

Code

CleannessLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AntibacterialProphylaxisID tabeli Surgery

Definicja kolumny AntibacterialProphylaxisID tabeli Surgery

Name

AntibacterialProphylaxisID

Code

AntibacterialProphylaxisID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli Surgery

Definicja kolumny PerfServiceID tabeli Surgery

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SurgeryDT tabeli Surgery

Definicja kolumny SurgeryDT tabeli Surgery

Name

SurgeryDT

Code

SurgeryDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna WoundDT tabeli Surgery

Definicja kolumny WoundDT tabeli Surgery

Name

WoundDT

Code

WoundDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli Surgery

Definicja kolumny Comments tabeli Surgery

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OtherDrainage tabeli Surgery

Definicja kolumny OtherDrainage tabeli Surgery

Name

OtherDrainage

Code

OtherDrainage

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OtherBodyPart tabeli Surgery

Definicja kolumny OtherBodyPart tabeli Surgery

Name

OtherBodyPart

Code

OtherBodyPart

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna WoundToClean tabeli Surgery

Definicja kolumny WoundToClean tabeli Surgery

Name

WoundToClean

Code

WoundToClean

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RoomNo tabeli Surgery

Definicja kolumny RoomNo tabeli Surgery

Name

RoomNo

Code

RoomNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ICDCode tabeli Surgery

Definicja kolumny ICDCode tabeli Surgery

Name

ICDCode

Code

ICDCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna SurgeryDescr tabeli Surgery

Definicja kolumny SurgeryDescr tabeli Surgery

Name

SurgeryDescr

Code

SurgeryDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Implant tabeli Surgery

Definicja kolumny Implant tabeli Surgery

Name

Implant

Code

Implant

Data Type

NUMBER(5)

Mandatory

No

Comment

Informacja o tym czy podczas zabiegu dokonano wszczepu czy tez nie.
Surgery.Implant = 1 - jest wszczep
Surgery.Implant = 0 - nie ma wszczepu
Surgery.Implant = null - wartosc nieokreslona


Kolumna OtherAntibacterialProphylaxis tabeli Surgery

Definicja kolumny OtherAntibacterialProphylaxis tabeli Surgery

Name

OtherAntibacterialProphylaxis

Code

OtherAntibacterialProphylaxis

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Informacje na temat profilaktyki przeciwbakteryjnej okolooperacyjnej


Kolumna DaysBeforeSurgery tabeli Surgery

Definicja kolumny DaysBeforeSurgery tabeli Surgery

Name

DaysBeforeSurgery

Code

DaysBeforeSurgery

Data Type

NUMBER(5)

Mandatory

No

Comment

Ilosc dni przed zabiegiem


Kolumna LengtheningSurgery tabeli Surgery

Definicja kolumny LengtheningSurgery tabeli Surgery

Name

LengtheningSurgery

Code

LengtheningSurgery

Data Type

NUMBER(3)

Mandatory

No

Comment

Przedluzenie zabiegu


Kolumna RepeatSurgery tabeli Surgery

Definicja kolumny RepeatSurgery tabeli Surgery

Name

RepeatSurgery

Code

RepeatSurgery

Data Type

NUMBER(3)

Mandatory

No

Comment

Ponowne przeprowadzenie zabiegu


Kolumna AntibacterialProphylaxisChemo tabeli Surgery

Definicja kolumny AntibacterialProphylaxisChemo tabeli Surgery

Name

AntibacterialProphylaxisChemo

Code

AntibacterialProphylaxisChemo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Chemoterapeutyk przy profilaktyce przeciwbakteryjnej


Kolumna AntibacterialProphylaxisDosNo tabeli Surgery

Definicja kolumny AntibacterialProphylaxisDosNo tabeli Surgery

Name

AntibacterialProphylaxisDosNo

Code

AntibacterialProphylaxisDosNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Ilosc dawek chemoterapeutyka przy profilaktyce przeciwbakteryjnej


Kolumna MultiProceduralSurgery tabeli Surgery

Definicja kolumny MultiProceduralSurgery tabeli Surgery

Name

MultiProceduralSurgery

Code

MultiProceduralSurgery

Data Type

NUMBER(5)

Mandatory

No

Comment

Okreslenie czy zabieg byl wieloproceduralny


Kolumna Trauma tabeli Surgery

Definicja kolumny Trauma tabeli Surgery

Name

Trauma

Code

Trauma

Data Type

NUMBER(5)

Mandatory

No

Comment

Okreslenie czy wystapil uraz


Kolumna ASA tabeli Surgery

Definicja kolumny ASA tabeli Surgery

Name

ASA

Code

ASA

Data Type

NUMBER(10)

Mandatory

No

Comment

Okreslenie skali ASA ze slownika w Dictionary (-481)


Kolumna Videosurgery tabeli Surgery

Definicja kolumny Videosurgery tabeli Surgery

Name

Videosurgery

Code

Videosurgery

Data Type

NUMBER(5)

Mandatory

No

Comment

Czy zabieg byl typu Wideooperacja


Lista kluczy tabeli Surgery

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Surgery

Definicja klucza Identifier_1 tabeli Surgery

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment